SAKTHIDBTECHNOLOGY - STUDENTS PORTAL

+ ADD Question

Qid	Examcode	Question	Qimpath	opt1	opt2	opt3	opt4	opt5	opt6	opt7	answers	CR
65	1Z0-064	In which three scenarios would you recommend the use of the SQL Performance Analyzer?		to identify SQL statements that require SQL profiles	to analyze the impact of network and interconnect changes on database workload	to identify SQL statements whose performance may have regressed due to a hardware upgrade	to analyze the impact of new indexes and materialized views on the SQL statements executed by an application	to identify SQL statements in an application whose performance may have regressed due to migration from Oracle Database 11g to 12c	to analyze the impact of using bind variables for syntactically similar SQL statements		1,2,3	MC
64	1Z0-064	Your database supports an OLTP workload where applications primarily perform small random I/Os. You notice an increase in the I/O requests queued up against the storage, and an increase in the wait time in queue. The database uses file system storage. What would you recommend to decrease the wait time of I/O requests?		Decrease the value of the DBWR_IO_SLAVES parameter.	Increase the size of the buffer cache.	Increase the value of the DB_WRITER_PROCESSES parameter.	Suggest storage admin to add more disks (spindles) to storage and stripe data across disks.				2	SC
63	1Z0-064	You are administrating a database that supports an OLTP workload. A few users complain about the poor performance of some SQL statements. You notice that these SQL statements belong to different applications and conclude that there is no correlation between them. You create a SQL Tuning Set (STS) containing these SQL statements. What must you do to analyze and generate recommendations for the SQL statements in the STS?		Submit the STS as input to the SQL Performance Analyzer to generate recommendations for creating indexes and materialized views.	Submit the STS as input to the SQL Tuning Advisor to generate recommendations for indexes or SQL profiles or both.	Submit the STS as input to the SQL Tuning Advisor to generate recommendations for SQL plan baselines.	Submit the STS as input to the SQL Access Advisor to generate recommendations for SQL profiles.				3	SC
62	1Z0-064	You are administrating a database that supports a mixed workload. Applications are running on a middle tier and use connection pooling to connect to the database instance. You want to trace all applications and modules that use the ORCL1 service to connect to the database instance. How would you consolidate the SQL statements for sessions that are connected by using the ORCL1 service?		by using the DBMS_MONITOR package to enable tracing, the trcsess utility to consolidate trace files, and the tkprof utility to interpret trace files	by setting TRACE_ENABLED = TRUE and using the tkprof utility to consolidate and interpret trace files	by setting SQL_TRACE = TRUE and using the tkprof utility to consolidate and interpret trace files	by using the DBMS_MONITOR package to enable tracing, the tkprof utility to consolidate trace files, and the trcsess utility to interpret trace files	by using the DBMS_TRACE package to enable tracing and the tkprof utility to consolidate and interpret trace files			3	SC
61	1Z0-064	For which two tasks would you recommend the use of a repeating baseline template?		to capture AWR data during a system test that is scheduled for a weekend	to capture AWR data for a scheduled job that runs every day over a specified period of time	to capture user activity information for a consumer group over a specified period of time	to capture AWR data for a specified contiguous time period on an ongoing basis	to capture statistics performance variation over a specified period of time			2,4	MC
60	1Z0-064	You are administrating a database that supports an OLTP workload. A new application module is deployed that is shipped along with the SQL plan baselines for the SQL statements executed by the application. You load the SQL plan baselines to the SQL Management Base. Examine the parameters:	png60.png	The SQL plan baselines are used but better execution plans may be found and can be evolved manually for the SQL statements.	The SQL plan baselines are used by the SQL statements and ensure that the best plan is used.	The SQL plan baselines are not used by the SQL statements if the optimizer statistics are stale.	The SQL plan baselines are loaded but are not used until SQL profiles are generated for the SQL statements.				3,4	MC
59	1Z0-064	You want to set a priority for the workloads generated by the applications in your database instance such that report-generating tasks are assigned a lower priority. How would you do this?		by using job classes with the Resource Manager	by creating an active session pool using the Resource Manager	by using services that are assigned different priorities with the Resource Manager	by using services for the applications and creating job classes associated with each service				3	SC
58	1Z0-064	In your database, supporting an OLTP workload, the SALES table is range-partitioned on the SALES_DATE column. A new partition is created every quarter and is frequently used for updates and queries. You recently noticed degraded performance of queries on a new partition due to stale statistics. A local partitioned index exists on the SALES_DATE column. What would you recommend to improve performance?		dropping the local partitioned index and creating a global partitioned index on the SALES_DATE column	setting the INCREMENTAL preference to TRUE and the NO_INVALIDATE preference to TRUE for the partitioned table while gathering statistics	setting the INCREMENTAL preference to TRUE and the CASCADE preference to FALSE for the partitioned table while gathering statistics	setting the INCREMENTAL preference to TRUE and the GRANULARITY preference to AUTO for the partitioned table while gathering statistics				4	SC
57	1Z0-064	You are administrating a database that supports a mixed workload. Given are the details of the workload: During the day, short transactions and syntactically similar queries are repeatedly issued. At night, DSS batch queries and jobs are executed with large sort operations. Examine the parameters set for the database instance:	png57.png	Set the MEMORY_MAX_TARGET and MEMORY_TARGET parameters to a value greater than the sum of SGA_MAX_SIZE and PGA_AGGREGATE_TARGET.	Set the SGA_TARGET and PGA_AGGREGATE_TARGET parameters to their minimum required values.	Set DB_CACHE_SIZE, SHARED_POOL_SIZE, and LARGE_POOL_SIZE to their minimum required values.	Set the SGA_TARGET parameter to the value of the SGA_MAX_SIZE parameter.	Set the MEMORY_TARGET parameter to the value of SGA_MAX_SIZE.			2,3,4	MC
56	1Z0-064	Examine the parameters set for your database instance:	png56.png	Reorganize the TRANS table online by using the DBMS_REDEFINITION package.	Create a bigger non-standard blocksize tablespace and move the TRANS table to that tablespace.	Move the TRANS table to a tablespace with manual segment space management with a lower value set for the PCTUSED attribute.	Move the TRANS table to a tablespace with manual segment space management with a higher value set for the PCTFREE attribute.				1,4	MC
55	1Z0-064	You want to enable the Database Smart Flash Cache feature on your database. For this purpose, you configure two flash devices: /dev/sdj and /dev/sdk, with sizes of 64 GB and 32 GB, respectively. Examine the parameters set for your database instance:	png55.png	by disabling Automatic Memory Management, setting SGA_TARGET to 96G, and setting the required memory that you want to set for SGA	by setting the value of the DB_FLASH_CACHE_SIZE parameter to 8G	by configuring the DB_FLASH_CACHE_SIZE parameter and making sure that all flash devices are of the same size	by setting the DB_FLASH_CACHE_SIZE parameter to 86G and the MEMORY_TARGET parameter to 112G	by setting the value of the DB_FLASH_CACHE_SIZE parameter to 64G, 32G			5	SC
54	1Z0-064	Examine the query and its output:	png54.png	Query V$SQLAREA to find out if the SQL statement is bind aware.	Query V$SQLAREA to find out if multiple sessions executed this SQL statement, which resulted in multiple entries in V$SQL.	Query V$SQL to find out if any invalidations or reloads occurred for this SQL statement.	Query V$SQL_SHARED_CURSOR to identify the reason that a child cursor cannot be shared.				4	SC
53	1Z0-064	Which two statements are true about the interpretation of Buffer Cache Hit Ratio in the Instance Efficiency Percentages section of an AWR report? (Choose two.)		A high value indicates that the buffer cache is adequately sized for the current workload.	Poor hit ratios indicate that a large number of indexed lookups or small table scans are being performed.	A low hit ratio does not necessarily imply that increasing the size of the buffer cache will improve performance.	A high hit ratio may indicate that repeated scanning of the same large table or index is being performed.	A low hit ratio indicates that a KEEP buffer pool should be configured based on the size of the largest object accessed in the buffer cache.			3,5	MC
52	1Z0-064	Which four objectives are achieved by using Resource Manager to manage multiple concurrent user sessions that are competing for resources? (Choose four.)		distributing available CPU by allocating percentages of CPU time to different users and applications	limiting the degree of parallelism of any operation performed by members of a group of users	limiting queries based on resource consumption of runaway sessions or calls that consume more than a specified amount of CPU, physical I/O, logical I/O, or elapsed time	limiting the number of concurrent sessions for a user	limiting the number of user sessions allowed to be concurrently active within a group of users	limiting the number of parallel executions that can be executed by a user		1,3,5,6	MC
51	1Z0-064	Which two statements are true about server-generated alerts? (Choose two.)		They are always logged in the alert log.	They are written to a trace file if the TRACE_ENABLED initialization parameter is set to TRUE.	They are generated only when the STATISTICS_LEVEL initialization parameter is set to ALL.	They can be generated for user-defined metric thresholds.	They appear in the DBA_ALERT_HISTORY view whenever corrective action is taken for an alert.			3,4	MC
50	1Z0-064	Examine the parameters:	png50.png	increasing the value of the SORT_AREA_SIZE parameter	increasing the value of the PGA_AGGREGATE_TARGET parameter	enabling Automatic Memory Management for the instance	increasing the size of the default temporary tablespace	using parallel hint in queries performing large sort operations	enabling Automatic Shared Memory Management for the instance		1,6	MC
49	1Z0-064	Your database supports an online transaction processing (OLTP) workload. The database uses ASM storage. One of the ASM disks goes offline because of hardware failure. When the disk is replaced and then added back to the diskgroup, database performance is affected by rebalance operations. Which two actions would you recommend to lower the impact of rebalance operations on the performance of the database? (Choose two.)		Increase the number of ASMB processes.	Decrease the value of the ASM_POWER_LIMIT parameter.	Set the DISK_REPAIR_TIME disk attribute to a lower value.	Specify the POWER clause with a lower value in an ALTER DISKGROUP statement.	Set the DISK_REPAIR_TIME disk attribute to a higher value.			2,4	MC
48	1Z0-064	You are administering a database that supports a mixed workload. The CURSOR_SHARING parameter is set to the default value. While analyzing the latest Automatic Workload Repository (AWR) report, you find a large number of cursor: pin S wait on X, cursor: pin X wait on S, and library cache mutex waits in the Top 10 foreground events section. Examine the Instance Efficiency Percentages section in the AWR report:	png48.png	Sessions are waiting for mutexes in share mode on cursors but other sessions are holding the mutexes in exclusive mode.	The CPU is spending more time in finding cursors in the library cache.	Cursors are not getting shared, resulting in a large number of hard parses.	Sessions are waiting for mutexes in exclusive mode on cursors but other sessions are holding the mutexes in share mode.	The buffers required by queries are not found in the buffer cache, thereby increasing expensive disk I/O.			2,4,5	MC
47	1Z0-064	Which two statements are true about ADDM or Real-Time ADDM? (Choose two.)		ADDM can be run manually by selecting any range of AWR snapshots available within the AWR retention period, provided they do not cover a time period when the instances were restarted.	ADDM runs in Partial mode to analyze any hung database issues.	Real-Time ADDM can proactively detect and diagnose transient performance issues that last for a few seconds.	Real-Time ADDM is automatically invoked by ADDM at the end of every hour.				2,3	MC
46	1Z0-064	Examine the parameters set for your database instance: Which two actions would you recommend to improve performance? (Choose two.)	png46.png	Create the KEEP cache and cache the tables used in the queries.	Set the CURSOR_SHARING parameter to FORCE.	Use bind variables instead of literals.	Create SQL plan baselines for the almost identical SQL statements and load them into the cursor cache.	Set the OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES parameter to TRUE.			2,5	MC
45	1Z0-064	A senior DBA asks you to decrease the values of the connect_time_scale and think_time_scale replay processing parameters to 50 to preprocess the workload for replay. What three could be reasons for this change? (Choose three.)		to reduce the elapsed time between two successive user calls from a session.	to decrease the number of concurrent users during replay	to increase the number of concurrent users during replay	to reduce the time of replay	to decrease the wait for a query, caused by noncommitted transactions			3,4,5	MC
44	1Z0-064	You are administering a database that supports an OLTP workload. RESULT_CACHE_MODE is set to the default value and a result cache is configured for the instance. Multiple sessions execute syntactically similar queries without dblinks, containing functions and expressions, on tables with no DML activity. Some users complain about poor performance of these queries. You investigate and find that the queries are frequently performing physical I/O, even though the results fetched by the queries are similar. Which two actions do you recommend to overcome the problem affecting these queries? (Choose two.)		Set the RESULT_CAHCE_MODE parameter to FORCE for the instance.	Use the result cache hint in the queries.	Use bind variables for similar queries instead of literals.	Set the RESULT_CACHE_REMOTE_EXPIRATION parameter to a nonzero value.	Configure the KEEP pool and cache the queried tables used in the KEEP pool.			1,2	MC
43	1Z0-064	Examine the partial Activity Over Time section of an Active Session History (ASH) report: Which two inferences are correct? (Choose two.)	png43.png	In the first time slot, five different sampled sessions were connected to the database instance.	In the second time slot, out of the nine sampled sessions connected to the database instance, only one sampled session was idle at the time of report generation.	In the first time slot, only one sampled session was using the CPU.	In the second time slot, five different sampled sessions were using the CPU.	In the second time slot, 0.14% of the time was spent on the CPU.			1,5	MC
42	1Z0-064	You have been asked to use table compression for two large tables. Given are the details of the tables: The TRANS_DET table: The table is used by an OLTP application. High volume insert and update operations are performed on the table. The table is frequently queried using index range scans. The TRANS_HISTORY table: The table is used by a DSS application. High volume bulk loads are performed on the table. The table is used to store archival data on which large table full-table scans (FTS) are performed. Which row store compression would you recommend for these tables with minimal overhead on performance? (Choose the best answer.)		basic table compression for both the tables	advanced row compression for both the tables	basic table compression for the TRANS_HISTORY table and advanced row compression for the TRANS_DET table	basic table compression for the TRANS_DET table and advanced row compression for the TRANS_HISTORY table	warehouse compression for the TRANS_DET table and archive compression for the TRANS_HISTORY table			1	SC
41	1Z0-064	Which two statements are true about Active Session History (ASH)? (Choose two.)		The Data Sample size available in an ASH report is dynamic and, at any given moment, is directly related to the amount of work being performed.	ASH contains sampled data from all sessions that are connected to a database instance at any given moment.	ASH samples data from V$SESSION every second.	An ASH report can be used to identify the service that may be the cause of a transient performance problem.				3,4	MC
40	1Z0-064	Which three statements are true about the interpretation of an execution plan? (Choose three.)		The cost of the entire plan is indicated by the line with Id 0 and always includes both I/O and CPU resources.	The ROWS column indicates the cardinality of each operation and is always calculated by dividing the total number of rows in the table by the number of distinct values in the column used in the WHERE clause predicate.	A TABLE ACCESS FULL in the Operation column for a query with a WHERE clause occurs only if no index exists for the filter column.	An INDEX UNIQUE SCAN in the Operation column always implies that only one row will be returned.	A HASH JOIN in the Operation column always implies that two tables are joined by using an equijoin.			1,2,3	MC
39	1Z0-064	Examine the parameters set for a database instance:	png39.png	increasing the size of the database buffer cache	configuring Automatic Memory Management	configuring the KEEP buffer pool and altering tables to use the KEEP pool	pinning the cursors of the queries in the library cache	configuring the result cache for the instance			1,2	MC
38	1Z0-064	Users complain about increased response time for queries in your production database that supports an OLTP workload. On investigation, you notice a large number of db file scattered read, latch: cache buffers lru chain, and latch: cache buffers chains wait events: Identify three possible reasons for the increased response time. (Choose three.)		too many sort operations being performed	repeated simultaneous access to a block or small number of blocks	the shared pool is inadequately sized	queries not using indexes and performing full table scans	queries repeatedly fetching blocks that are not in the database buffer cache	cursors are closed explicitly after each execution		2,3,5	MC
37	1Z0-064	You are administering a database that supports a mixed workload. Many applications are running on the middle tier that use connection pools to connect to the database instance. Application users perform OLTP operations during the day and another application performs batch job operations at night. You want to measure and prioritize the two workloads. Which action would you take to achieve this? (Choose the best answer.)		Create database services for the applications, assign individual sessions created by the applications to consumer groups, and then set a priority.	Assign profiles to users running the batch operations and make sure that a priority is set for resource limits in profiles.	Create database services for the applications and assign different profiles to the sessions to set a relative priority for resource usage.	Create database services for the applications, create a job class associated with the service, batch the jobs, and then create jobs by using the job class.				3	SC
36	1Z0-064	Which two are prerequisites for running the I/O calibration tool? (Choose two.)		The database must be in MOUNT state.	The database should be opened in restricted mode.	For determining latency time, the STATISTICS_LEVEL parameter must be set to TYPICAL or ALL.	The disks to be tested must be configured to use asynchronous I/O for data files.	The database instance must be started using an SPFILE.			1,5	MC
35	1Z0-064	You plan to upgrade your production database from Oracle Database 11g to 12c and also to introduce new objects to the database.	35-quept.png	Database Replay	SQL Tuning Advisor	SQL Access Advisor	Automatic Database Diagnostic Monitor (ADDM) compare periods report	SQL Performance Analyzer	Automatic Workload Repository (AWR) compare periods report		2,5	MC
34	1Z0-064	Your database supports multiple applications. The applications run on the middle tier and use connection pooling for connecting to the database. You notice that the sessions created by the applications are competing for resources. You want to statistically measure the workload and set priorities. What action must you perform to achieve this? (Choose the best answer.)		Create services for the applications and set a relative priority by assigning them to application users and using the DBMS_MONITOR.SERV_MOD_ACT_TRACE_ENABLE procedure to trace the services.	Create services for the applications and set a relative priority by assigning them to application users and using the DBMS_MONITOR.SESSION_TRACE_ENABLE procedure to trace the services.	Create services for the applications and set the relative priority of services within an instance by mapping the services directly to consumer groups.	Create services for the applications and set a relative priority by assigning them to application users.				1	SC
33	1Z0-064	You want to capture the performance of your database during the last ten days of the first quarter of the current financial year, so that you can compare this performance against the remaining quarter ends of the current financial year. Which method should you use? (Choose the best answer.)		Create a static baseline that can be used with AWR compare reports.	Create a new moving window baseline and enable adaptive thresholds for relevant metrics.	Use a repeating baseline template to create and drop baselines based on a repeating time schedule and set adaptive thresholds at a high significance level.	Use fixed baseline templates to create a new moving window baseline and set relevant warning alerts that are computed as a percentage multiple of the maximum value observed for the data in the moving window baseline.				4	SC
32	1Z0-064	You define the warning threshold for the tablespace usage metric for the USERS tablespace to be 60% and the critical threshold to be 80%. Which two sources should you check for the alert information when either the warning or the critical threshold is exceeded? (Choose two.)		the alert log	Oracle Enterprise Manager Cloud Control	DBA_ALERT_HISTORY	DBA_OUTSTANDING_ALERTS	DBA_ACTIVE_SESSION_HISTORY	DBA_THRESHOLDS		1,6	MC
31	1Z0-064	You have been asked to assess if using column store compression (previously known as hybrid columnar compression or HCC) would help improve the performance of queries on some large tables. Which three aspects should you consider before you choose this compression method? (Choose three.)		Check whether direct path load operations are used to insert rows in the table.	Check whether the table is frequently queried using full table scans as column store compression only minimizes I/O during full table scans.	Check whether the table is frequently updated because it will have overhead for insert and update operations.	Check whether the table has LOB columns as it will minimize I/O for the queries.	Check whether the table blocks are sparsely populated as this will defragment the blocks.			1,2,4	MC
30	1Z0-064	You observe that queries are performing poorly on the SALES_RECORDS table in your database. On investigation, you find that at the end of each day the contents of the SALES_RECORDS table are moved to the SALES_HISTORY table. The delete operations cause the table to be sparsely populated. The SALES_RECORDS table is created in a tablespace using Automatic Segment Space Management (ASSM) and row movement is enabled. The table must be accessible 24x7. Which two tasks would you recommend to improve the performance? (Choose two.)		Perform EXPORT, DROP, and IMPORT operations on the SALES_RECORDS table.	Shrink the SALES_RECORDS table by using the ALTER TABLEâ€¦SHRINK SPACE command.	Move the SALES_RECORDS table to a different location by using the ALTER TABLEâ€¦MOVE command.	Deallocate the space in the SALES_RECORDS table by using the ALTER TABLEâ€¦DEALLOCATE UNUSED command.	Move the SALES_RECORDS table to a tablespace by using manual segment space management.	Reorganize the SALES_RECORDS table online by using the DBMS_REDEFINITION package.		2,4	MC
29	1Z0-064	To investigate the slow response time of queries on the TRANS table, you gathered the table statistics and executed the query:	png29.png	Row size is too large to fit into a single block during insert operations.	Row moves from one data block to another data block because the row grows too large to fit in the original block.	The table is subject to frequent insert, update, and delete DML activity leading to sparsely populated blocks.	The value of PCTUSED is set to a value lower than the default, causing row chaining.	The value of PCTFREE is set to a value lower than the default, causing row chaining.			1,2,4	MC
28	1Z0-064	For which two requirements can you always use the V$ACTIVE_SESSION_HISTORY view? (Choose two.)		to investigate intermittent performance problems in a session, only when the problem lasted less than five minutes in the last twelve hours	to find the exact number of executions of a specific query in a session in the last two minutes	to identify which module in an application was being executed in a session	to identify a scheduler job that is not responding	to find the amount of Program Global Architecture (PGA) memory being currently consumed by a session			3,5	MC
27	1Z0-064	Which three statements are true about using Real-Time Database Operations? (Choose three.)		The STATISTICS_LEVEL initialization parameter must be set to ALL to enable automatic SQL monitoring for all long-running queries.	The CONTROL_MANAGEMENT_PACK_ACCESS initialization parameter must be set to DIAGNOSTIC+TUNUNG to use Real-Time Database Operations.	The STATISTICS_LEVEL initialization parameter can be set to TYPICAL or ALL to enable Real-Time Database Operations.	Real-Time Database Operations can be enabled only at the system level.	Real-Time Database Operations can be created by using the DBMS_MONITOR or DBMS_SESSION packages.	Database operation monitoring starts automatically when a database operation consumes at least five seconds of the CPU or I/O time in a single execution.		1,2,3	MC
26	1Z0-064	You execute this query twice in a session:	png26.png	No statistics were collected during the first execution of the query.	A subsequent execution of the query in this session is likely to undergo a soft parse.	The second execution of the query was hard parsed because the estimated cardinality was inaccurate.	A subsequent execution of the query in this session will undergo a hard parse.	The second execution of the query was hard parsed because extended statistics were collected after the first execution of the query.			2,3	MC
25	1Z0-064	Your database supports an OLTP workload during the day and batch processing at night.	25-quept.png	5,7	2,4,3	3,4,8	4,5,7	5,1,6,8			5	SC
24	1Z0-064	Examine an extract from a PGA Memory Advisory for your database:	png24.png	Automatic management of PGA memory is disabled.	The current PGA size requires the use of a temporary tablespace for sorting operations.	The current PGA size is sufficient and does not require the memory manager to allocate more memory.	PGA size should be increased at least four times its current size for significant improvement in performance and disk space management.				2,4	MC
23	1Z0-064	You are administering a database that supports an OLTP workload. CURSOR_SHARING is set to EXACT for the instance. An application is frequently executing almost identical queries that vary in literal values in the WHERE clause, causing a large number of hard parses to occur. Which four statements would be true if you use bind variables for these queries? (Choose four.)		Mutex contention in the library cache will be reduced.	The optimizer will use one parent cursor and one child cursor for each SQL statement with different literal values.	Hard parses will be reduced for the queries.	The optimizer will use bind peeking and subsequent execution of the queries will always generate the same plans irrespective of the cardinality.	The optimizer will generate the same plan for all bind values if no histograms exist on the columns used in the WHERE clause of these queries.	The optimizer will use bind peeking and use the literal value to determine the execution plan for these queries.		1,2,3,4	MC
22	1Z0-064	Which two statements are true about DB time in V$SYS_TIME_MODEL? (Choose two.)		DB time cannot exceed the total elapsed time (walk clock time) since the database instance started.	DB time cannot exceed the maximum number of concurrent sessions multiplied by the actual elapsed time for each session.	DB time includes the time spent on client processes and background processes.	Reducing DB time allows a database instance to support more user requests by using the same resources.	DB time is always greater than or equal to the DB CPU time.			4,5	MC
21	1Z0-064	Examine the parameters set for your database instance:	png21.png	Set the SGA_TARGET parameter equal to SGA_MAX_SIZE.	Set the SGA_TARGET parameter to the sum of DB_CACHE_SIZE, SHARED_POOL, and LARGE_POOL_SIZE.	Set the MEMORY_MAX_TARGET parameter to the sum of DB_CACHE_SIZE, SHARED_POOL, and LARGE_POOL_SIZE.	Set DB_CACHE_SIZE, SHARED_POOL, and LARGE_POOL_SIZE to their minimum required values.	Set the PGA_AGGREGATE_TARGET parameter to 0 and the SGA_TARGET parameter to 1.5G.			1,5	MC
20	1Z0-064	Which three methods can you use to create a pre-change SQL trial to capture performance data by using SQL Performance Analyzer? (Choose three.)		executing SQL statements in a SQL Tuning Set (STS) on a test database by using database links to the production database.	generating only execution plans on a test database without actually running SQL statements.	generating an execution plan and statistics for selective SQL statements captured in an STS	loading performance data and execution plans from an STS.	generating both execution plans and statistics for each SQL statement in an STS by actually running the SQL statements on a test database.			1,2,3	MC
19	1Z0-064	Which two result in the least internal fragmentation within segments and the least external fragmentation within tablespaces? (Choose two.)		automatic segment space managed segments	locally managed tablespaces with uniform extent size	freelist managed segments with one freelist	dictionary managed tablespaces	locally managed tablespaces that were converted from dictionary managed tablespaces	freelist managed segments with multiple freelists		1,4	MC
18	1Z0-064	You are administering a database that supports an OLTP workload. The CURSOR_SHARING parameter is set to EXACT for the instance. The performance of queries issued by one of the modules has degraded. The queries executed by the module are almost identical in syntax. To investigate, you analyze the latest AWR report and find a large number of latch:shared pool wait events and also a high percentage of the hard parse elapsed time. Which two can be reasons for this? (Choose two.)		The I/O performance is slow.	Bind variables are not used for similar queries, causing hard parses.	Repeated access to a small number of blocks.	Excessive time is spent on finding cached cursors in the library cache.	The CURSOR_SHARING parameter is set to EXACT, which does not allow similar queries to share a cursor.			2,3	MC
17	1Z0-064	Which two statements are true about Compare Period ADDM? (Choose two.)		It is automatically invoked whenever the AWR Compare Period report is invoked.	It is automatically invoked whenever ADDM is run by default.	It verifies if there is any change in the workload or average resource consumption by the SQL executed during the two specified time periods, to ensure 100% accuracy.	It can be used to create a comparison report between the Database Replay workload capture report and the replay report.				2,4	MC
16	1Z0-064	For which three problem categories does Automatic Database Diagnostic Monitor (ADDM) provide analysis and recommendations by default? (Choose three.)		for network stack-related bandwidth contention	for concurrency issues because of buffer busy problems	for high-load PL/SQL execution and compilation, and high-load Java usage	for application-level lock contention.				2,3,4	MC
15	1Z0-064	Which two situations can lead to sparsely populated index blocks? (Choose two.)		Data is frequently inserted using direct path load into a table with an index.	Indexed columns in a table are frequently updated.	Values in an indexed column are inserted using monotonically incrementing sequences.	Bulk delete operations are performed on a table with indexes.	Online table move operations are performed frequently on a table with indexes.			4,5	MC
14	1Z0-064	In which three situations does DB time always increase? (Choose three.)		when the host is CPU bound for foreground processes	when I/O wait time increases for foreground processes	when more connections are made to a database instance	when CPU consumption by background processes increases	when wait time for data to be sent over a network increases			2,3,4	MC
13	1Z0-064	Examine the query and its output:	13-quept.png	Session 2832 had to wait 2029 seconds for a message to arrive because of a network bottleneck.	Session 4208 is either idle or experiencing poor response time due to a network or resource bottleneck on the client process.	Session 3346 is in wait state because it wants to lock a row in a block in which other sessions have already locked rows, and there is no free ITL slot available in this block.	Session 3346 is in wait state because either it is waiting to update a row that is locked by another session or another session is trying to insert the same key value in a UNIQUE index	Session 4208 is definitely idle and should be killed to free network resources.			1,4	MC
12	1Z0-064	Identify two effects of the DB_FILE_MULTIBLOCK_READ_COUNT parameter on the optimizer. (Choose two.)		Decreasing the value of DB_FILE_MULTIBLOCK_READ_COUNT from the default increases the cost of index probes for DSS workloads.	A full table scan can become cheaper than index scans if the database instance has a high enough DB_FILE MULTIBLOCK_READ_COUNT for both OLTP and DSS workloads.	Increasing the value of DB_FILE_MULTIBLOCK_READ_COUNT within OS limits lowers the costing of an index probe that is done in conjunction with a nested loop for OLTP workloads.	In DSS workloads where full table scans may run in parallel and bypass the buffer cache, decreasing the value of DB_FILE_MULTIBLOCK_READ_COUNT from the default increases the cost of full table scans.	Increasing the value of DB_FILE_MULTIBLOCK_READ_COUNT within OS limits lowers the cost of full table scans and can result in the optimizer choosing a full table scan over an index scan for both OLTP and DSS workloads.			3,4	MC
11	1Z0-064	Your database supports an OLTP system.	11-quept.png	creating a bitmap index on the COUNTRY_ID column	regathering statistics on the CUSTOMERS table	gathering statistics on the COUNTRY_IDX index	creating a histogram on the COUNTRY_ID column	increasing the size of the PGA	creating a SQL profile	creating a KEEP cache	1,4	MC
10	1Z0-064	You are administering a database that supports an OLTP workload. An application regularly creates global temporary tables and a large number of transactions are performed on them. You notice that performance is degraded because of excessive generation of undo due to a large number of transactions on the global temporary tables. What is the recommended action to improve performance? (Choose the best answer.)		Increase the size of the undo tablespace and enable undo retention guarantee.	Increase the size of the database buffer cache.	Enable temporary undo.	Increase the size of the temporary tablespace or make it autoextensible.	Enable Automatic Segment Space Management (ASSM) for the undo tablespace.			1	SC
9	1Z0-064	Examine the query and its output:	09-quept.png	The db file scattered read event has occurred 104 times in this session for file# 12.	The session has completed performing a full table scan.	The SQL statements in this session are performing excessive disk reads.	The multiblock factor is 8 for this I/O but it could vary for the other I/O events.				1,3	MC
8	1Z0-064	You are administering a database that supports a DSS workload. Automatic Shared Memory Management is enabled for the database instance. Users issue queries to perform large soft operations and complain about degraded performance of the queries. On investigation, you notice that the queries are performing multipass work area executions and the I/O contention on one of the temporary tablespaces is very high. Which two can be possible resolutions for this issue? (Choose two.)		Increase the size of the large pool.	Increase the value of the PGA_AGGREGATE_TARGET parameter.	Create a temporary tablespace group and assign it to users.	Increase the value of the PGA_AGGREGATE_LIMIT parameter.	Create another temporary tablespace and assign it to users.	Enable temporary undo.		1,4	MC
7	1Z0-064	Which two actions should you take to monitor the throughput generated by the modules of an application? (Choose two.)		Use the Resource Manager.	Enable SQL Trace at the session level.	Create a service.	Use a dedicated server configuration.	Use the DBMS_APPLICATION_INFO package to define the current module and action so that they appear in V$SESSION.			1,2	MC
6	1Z0-064	For your database some users complain about not being able to execute transactions. Upon investigation, you find that the problem is caused by some users performing long-running transactions that consume huge amounts of space in the UNDO tablespace. You want to control the usage of the UNDO tablespace only for these user sessions. How would you avoid the issue from repeating in future? (Choose the best answer.)		Create a profile for the users with the LOGICAL_READS_PER_SESSION and LOGICAL_READS_PER_CALL limits defined.	Create external roles to restrict the usage of the UNDO tablespace and assign them to the users.	Set the threshold for UNDO tablespace usage for the users.	Implement a Database Resource Manager plan by mapping the users to a resource consumer group with limits defined for UNDO tablespace usage.				4	SC
5	1Z0-064	Examine the partial AWR report taken for a time period of 60 minutes:	05-quept.png	The database user calls are issuing frequent explicit commits.	The CPUs are busy executing server processes and background processes for a considerable amount of CPU time.	The database user calls are spending most of their time in I/O for single block reads.	The database user calls are spending most of their time waiting for sessions that are in more important consumer groups.				2,3	MC
4	1Z0-064	Examine the partial TOP 10 Foreground Events by Total Wait Time section of an AWR report:	png4.png	the V$ACTIVE_SESSION_HISTORY view	the Time Model Statistics section of the AWR report	the SQL statements based on elapsed time from the AWR report	the Latch Activity section	the Segment Statistics section of the AWR report			2	SC
3	1Z0-064	Examine the Time Model Statistics section of an AWR report:	png3.png	The available CPU resources were not utilized to their maximum capacity.	All sequence numbers used during this AWR time interval were cached.	A large number of connected user sessions were idle.	New child cursors were created because of new bind values or usage of literal values as well as different bind types or sizes.	The DB CPU time was not spent exclusively for processing SQL statements.			4,5	MC
2	1Z0-064	You recently joined a new team administering a database. You notice that full table scans are performing poorly compared with full table scans on the databases you administered in a previous job. You decide that performance problems are caused by a misconfiguration of factors affecting full table scans. Which three factors should you investigate to determine the cause of the poorly performing Full Table Scans (FTS)? (Choose three.)		value of DB_FILE_MULTIBLOCK_READ_COUNT	storing query results in the result cache	setting of the DISK_ASYNC_IO parameter to TRUE	setting of the OPTIMIZER_MODE parameter to ALL_ROWS	use of parallel queries	block size of the tablespaces in which the tables being scanned are stored	value of the OPTIMIZER_DYNAMIC_SAMPLING parameter	1,2,3	MC
1	1Z0-064	You plan to upgrade your production database from Oracle Database 11g to 12c. As part of the upgrade, you want to introduce new indexes and materialized views. You have already created a test system with Oracle Database 12c, having the same structure and data as the production database, along with new schema objects to be added to the production database. You want to identify regressed SQL statements, if any, which may have been caused by schema changes and the change in the optimizer version. Which two methods would you use to achieve this? (Choose two.)		Create an SQL Tuning Set (STS) for the SQL statements on the production database and submit as input to the SQL Tuning Advisor on the test database.	Create an STS for the SQL statements on the production database and submit as input to the SQL Performance Analyzer with the OPTIMIZER_FEATURES_ENABLE parameter first set to 11.2.0.1, and then to 12.1.0.1on the test database.	Generate an Automatic Workload Repository (AWR) compare periods report with snapshots taken before and after schema changes on the test database.	Capture the production database workload, replay it on the test system by using Database Replay, and analyze by using the workload replay compare period report.	Create an STS for the SQL statements on the production database and submit as input to the SQL Access Advisor on the test database.	Create an STS for the SQL statements on the production database before and after changes and submit as input to the SQL Performance Analyzer on the test database.		1,4	MC